package com.eipv.multidatasource.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class UspcServiceinfoCompExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public UspcServiceinfoCompExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andServiceSeqidIsNull() {
            addCriterion("SERVICE_SEQID is null");
            return (Criteria) this;
        }

        public Criteria andServiceSeqidIsNotNull() {
            addCriterion("SERVICE_SEQID is not null");
            return (Criteria) this;
        }

        public Criteria andServiceSeqidEqualTo(String value) {
            addCriterion("SERVICE_SEQID =", value, "serviceSeqid");
            return (Criteria) this;
        }

        public Criteria andServiceSeqidNotEqualTo(String value) {
            addCriterion("SERVICE_SEQID <>", value, "serviceSeqid");
            return (Criteria) this;
        }

        public Criteria andServiceSeqidGreaterThan(String value) {
            addCriterion("SERVICE_SEQID >", value, "serviceSeqid");
            return (Criteria) this;
        }

        public Criteria andServiceSeqidGreaterThanOrEqualTo(String value) {
            addCriterion("SERVICE_SEQID >=", value, "serviceSeqid");
            return (Criteria) this;
        }

        public Criteria andServiceSeqidLessThan(String value) {
            addCriterion("SERVICE_SEQID <", value, "serviceSeqid");
            return (Criteria) this;
        }

        public Criteria andServiceSeqidLessThanOrEqualTo(String value) {
            addCriterion("SERVICE_SEQID <=", value, "serviceSeqid");
            return (Criteria) this;
        }

        public Criteria andServiceSeqidLike(String value) {
            addCriterion("SERVICE_SEQID like", value, "serviceSeqid");
            return (Criteria) this;
        }

        public Criteria andServiceSeqidNotLike(String value) {
            addCriterion("SERVICE_SEQID not like", value, "serviceSeqid");
            return (Criteria) this;
        }

        public Criteria andServiceSeqidIn(List<String> values) {
            addCriterion("SERVICE_SEQID in", values, "serviceSeqid");
            return (Criteria) this;
        }

        public Criteria andServiceSeqidNotIn(List<String> values) {
            addCriterion("SERVICE_SEQID not in", values, "serviceSeqid");
            return (Criteria) this;
        }

        public Criteria andServiceSeqidBetween(String value1, String value2) {
            addCriterion("SERVICE_SEQID between", value1, value2, "serviceSeqid");
            return (Criteria) this;
        }

        public Criteria andServiceSeqidNotBetween(String value1, String value2) {
            addCriterion("SERVICE_SEQID not between", value1, value2, "serviceSeqid");
            return (Criteria) this;
        }

        public Criteria andServTypeIsNull() {
            addCriterion("SERV_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andServTypeIsNotNull() {
            addCriterion("SERV_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andServTypeEqualTo(String value) {
            addCriterion("SERV_TYPE =", value, "servType");
            return (Criteria) this;
        }

        public Criteria andServTypeNotEqualTo(String value) {
            addCriterion("SERV_TYPE <>", value, "servType");
            return (Criteria) this;
        }

        public Criteria andServTypeGreaterThan(String value) {
            addCriterion("SERV_TYPE >", value, "servType");
            return (Criteria) this;
        }

        public Criteria andServTypeGreaterThanOrEqualTo(String value) {
            addCriterion("SERV_TYPE >=", value, "servType");
            return (Criteria) this;
        }

        public Criteria andServTypeLessThan(String value) {
            addCriterion("SERV_TYPE <", value, "servType");
            return (Criteria) this;
        }

        public Criteria andServTypeLessThanOrEqualTo(String value) {
            addCriterion("SERV_TYPE <=", value, "servType");
            return (Criteria) this;
        }

        public Criteria andServTypeLike(String value) {
            addCriterion("SERV_TYPE like", value, "servType");
            return (Criteria) this;
        }

        public Criteria andServTypeNotLike(String value) {
            addCriterion("SERV_TYPE not like", value, "servType");
            return (Criteria) this;
        }

        public Criteria andServTypeIn(List<String> values) {
            addCriterion("SERV_TYPE in", values, "servType");
            return (Criteria) this;
        }

        public Criteria andServTypeNotIn(List<String> values) {
            addCriterion("SERV_TYPE not in", values, "servType");
            return (Criteria) this;
        }

        public Criteria andServTypeBetween(String value1, String value2) {
            addCriterion("SERV_TYPE between", value1, value2, "servType");
            return (Criteria) this;
        }

        public Criteria andServTypeNotBetween(String value1, String value2) {
            addCriterion("SERV_TYPE not between", value1, value2, "servType");
            return (Criteria) this;
        }

        public Criteria andSpCodeIsNull() {
            addCriterion("SP_CODE is null");
            return (Criteria) this;
        }

        public Criteria andSpCodeIsNotNull() {
            addCriterion("SP_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andSpCodeEqualTo(String value) {
            addCriterion("SP_CODE =", value, "spCode");
            return (Criteria) this;
        }

        public Criteria andSpCodeNotEqualTo(String value) {
            addCriterion("SP_CODE <>", value, "spCode");
            return (Criteria) this;
        }

        public Criteria andSpCodeGreaterThan(String value) {
            addCriterion("SP_CODE >", value, "spCode");
            return (Criteria) this;
        }

        public Criteria andSpCodeGreaterThanOrEqualTo(String value) {
            addCriterion("SP_CODE >=", value, "spCode");
            return (Criteria) this;
        }

        public Criteria andSpCodeLessThan(String value) {
            addCriterion("SP_CODE <", value, "spCode");
            return (Criteria) this;
        }

        public Criteria andSpCodeLessThanOrEqualTo(String value) {
            addCriterion("SP_CODE <=", value, "spCode");
            return (Criteria) this;
        }

        public Criteria andSpCodeLike(String value) {
            addCriterion("SP_CODE like", value, "spCode");
            return (Criteria) this;
        }

        public Criteria andSpCodeNotLike(String value) {
            addCriterion("SP_CODE not like", value, "spCode");
            return (Criteria) this;
        }

        public Criteria andSpCodeIn(List<String> values) {
            addCriterion("SP_CODE in", values, "spCode");
            return (Criteria) this;
        }

        public Criteria andSpCodeNotIn(List<String> values) {
            addCriterion("SP_CODE not in", values, "spCode");
            return (Criteria) this;
        }

        public Criteria andSpCodeBetween(String value1, String value2) {
            addCriterion("SP_CODE between", value1, value2, "spCode");
            return (Criteria) this;
        }

        public Criteria andSpCodeNotBetween(String value1, String value2) {
            addCriterion("SP_CODE not between", value1, value2, "spCode");
            return (Criteria) this;
        }

        public Criteria andOperatorCodeIsNull() {
            addCriterion("OPERATOR_CODE is null");
            return (Criteria) this;
        }

        public Criteria andOperatorCodeIsNotNull() {
            addCriterion("OPERATOR_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andOperatorCodeEqualTo(String value) {
            addCriterion("OPERATOR_CODE =", value, "operatorCode");
            return (Criteria) this;
        }

        public Criteria andOperatorCodeNotEqualTo(String value) {
            addCriterion("OPERATOR_CODE <>", value, "operatorCode");
            return (Criteria) this;
        }

        public Criteria andOperatorCodeGreaterThan(String value) {
            addCriterion("OPERATOR_CODE >", value, "operatorCode");
            return (Criteria) this;
        }

        public Criteria andOperatorCodeGreaterThanOrEqualTo(String value) {
            addCriterion("OPERATOR_CODE >=", value, "operatorCode");
            return (Criteria) this;
        }

        public Criteria andOperatorCodeLessThan(String value) {
            addCriterion("OPERATOR_CODE <", value, "operatorCode");
            return (Criteria) this;
        }

        public Criteria andOperatorCodeLessThanOrEqualTo(String value) {
            addCriterion("OPERATOR_CODE <=", value, "operatorCode");
            return (Criteria) this;
        }

        public Criteria andOperatorCodeLike(String value) {
            addCriterion("OPERATOR_CODE like", value, "operatorCode");
            return (Criteria) this;
        }

        public Criteria andOperatorCodeNotLike(String value) {
            addCriterion("OPERATOR_CODE not like", value, "operatorCode");
            return (Criteria) this;
        }

        public Criteria andOperatorCodeIn(List<String> values) {
            addCriterion("OPERATOR_CODE in", values, "operatorCode");
            return (Criteria) this;
        }

        public Criteria andOperatorCodeNotIn(List<String> values) {
            addCriterion("OPERATOR_CODE not in", values, "operatorCode");
            return (Criteria) this;
        }

        public Criteria andOperatorCodeBetween(String value1, String value2) {
            addCriterion("OPERATOR_CODE between", value1, value2, "operatorCode");
            return (Criteria) this;
        }

        public Criteria andOperatorCodeNotBetween(String value1, String value2) {
            addCriterion("OPERATOR_CODE not between", value1, value2, "operatorCode");
            return (Criteria) this;
        }

        public Criteria andOperatorNameIsNull() {
            addCriterion("OPERATOR_NAME is null");
            return (Criteria) this;
        }

        public Criteria andOperatorNameIsNotNull() {
            addCriterion("OPERATOR_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andOperatorNameEqualTo(String value) {
            addCriterion("OPERATOR_NAME =", value, "operatorName");
            return (Criteria) this;
        }

        public Criteria andOperatorNameNotEqualTo(String value) {
            addCriterion("OPERATOR_NAME <>", value, "operatorName");
            return (Criteria) this;
        }

        public Criteria andOperatorNameGreaterThan(String value) {
            addCriterion("OPERATOR_NAME >", value, "operatorName");
            return (Criteria) this;
        }

        public Criteria andOperatorNameGreaterThanOrEqualTo(String value) {
            addCriterion("OPERATOR_NAME >=", value, "operatorName");
            return (Criteria) this;
        }

        public Criteria andOperatorNameLessThan(String value) {
            addCriterion("OPERATOR_NAME <", value, "operatorName");
            return (Criteria) this;
        }

        public Criteria andOperatorNameLessThanOrEqualTo(String value) {
            addCriterion("OPERATOR_NAME <=", value, "operatorName");
            return (Criteria) this;
        }

        public Criteria andOperatorNameLike(String value) {
            addCriterion("OPERATOR_NAME like", value, "operatorName");
            return (Criteria) this;
        }

        public Criteria andOperatorNameNotLike(String value) {
            addCriterion("OPERATOR_NAME not like", value, "operatorName");
            return (Criteria) this;
        }

        public Criteria andOperatorNameIn(List<String> values) {
            addCriterion("OPERATOR_NAME in", values, "operatorName");
            return (Criteria) this;
        }

        public Criteria andOperatorNameNotIn(List<String> values) {
            addCriterion("OPERATOR_NAME not in", values, "operatorName");
            return (Criteria) this;
        }

        public Criteria andOperatorNameBetween(String value1, String value2) {
            addCriterion("OPERATOR_NAME between", value1, value2, "operatorName");
            return (Criteria) this;
        }

        public Criteria andOperatorNameNotBetween(String value1, String value2) {
            addCriterion("OPERATOR_NAME not between", value1, value2, "operatorName");
            return (Criteria) this;
        }

        public Criteria andBillFlagIsNull() {
            addCriterion("BILL_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andBillFlagIsNotNull() {
            addCriterion("BILL_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andBillFlagEqualTo(String value) {
            addCriterion("BILL_FLAG =", value, "billFlag");
            return (Criteria) this;
        }

        public Criteria andBillFlagNotEqualTo(String value) {
            addCriterion("BILL_FLAG <>", value, "billFlag");
            return (Criteria) this;
        }

        public Criteria andBillFlagGreaterThan(String value) {
            addCriterion("BILL_FLAG >", value, "billFlag");
            return (Criteria) this;
        }

        public Criteria andBillFlagGreaterThanOrEqualTo(String value) {
            addCriterion("BILL_FLAG >=", value, "billFlag");
            return (Criteria) this;
        }

        public Criteria andBillFlagLessThan(String value) {
            addCriterion("BILL_FLAG <", value, "billFlag");
            return (Criteria) this;
        }

        public Criteria andBillFlagLessThanOrEqualTo(String value) {
            addCriterion("BILL_FLAG <=", value, "billFlag");
            return (Criteria) this;
        }

        public Criteria andBillFlagLike(String value) {
            addCriterion("BILL_FLAG like", value, "billFlag");
            return (Criteria) this;
        }

        public Criteria andBillFlagNotLike(String value) {
            addCriterion("BILL_FLAG not like", value, "billFlag");
            return (Criteria) this;
        }

        public Criteria andBillFlagIn(List<String> values) {
            addCriterion("BILL_FLAG in", values, "billFlag");
            return (Criteria) this;
        }

        public Criteria andBillFlagNotIn(List<String> values) {
            addCriterion("BILL_FLAG not in", values, "billFlag");
            return (Criteria) this;
        }

        public Criteria andBillFlagBetween(String value1, String value2) {
            addCriterion("BILL_FLAG between", value1, value2, "billFlag");
            return (Criteria) this;
        }

        public Criteria andBillFlagNotBetween(String value1, String value2) {
            addCriterion("BILL_FLAG not between", value1, value2, "billFlag");
            return (Criteria) this;
        }

        public Criteria andFeeIsNull() {
            addCriterion("FEE is null");
            return (Criteria) this;
        }

        public Criteria andFeeIsNotNull() {
            addCriterion("FEE is not null");
            return (Criteria) this;
        }

        public Criteria andFeeEqualTo(String value) {
            addCriterion("FEE =", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeNotEqualTo(String value) {
            addCriterion("FEE <>", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeGreaterThan(String value) {
            addCriterion("FEE >", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeGreaterThanOrEqualTo(String value) {
            addCriterion("FEE >=", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeLessThan(String value) {
            addCriterion("FEE <", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeLessThanOrEqualTo(String value) {
            addCriterion("FEE <=", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeLike(String value) {
            addCriterion("FEE like", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeNotLike(String value) {
            addCriterion("FEE not like", value, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeIn(List<String> values) {
            addCriterion("FEE in", values, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeNotIn(List<String> values) {
            addCriterion("FEE not in", values, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeBetween(String value1, String value2) {
            addCriterion("FEE between", value1, value2, "fee");
            return (Criteria) this;
        }

        public Criteria andFeeNotBetween(String value1, String value2) {
            addCriterion("FEE not between", value1, value2, "fee");
            return (Criteria) this;
        }

        public Criteria andValidDateIsNull() {
            addCriterion("VALID_DATE is null");
            return (Criteria) this;
        }

        public Criteria andValidDateIsNotNull() {
            addCriterion("VALID_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andValidDateEqualTo(String value) {
            addCriterion("VALID_DATE =", value, "validDate");
            return (Criteria) this;
        }

        public Criteria andValidDateNotEqualTo(String value) {
            addCriterion("VALID_DATE <>", value, "validDate");
            return (Criteria) this;
        }

        public Criteria andValidDateGreaterThan(String value) {
            addCriterion("VALID_DATE >", value, "validDate");
            return (Criteria) this;
        }

        public Criteria andValidDateGreaterThanOrEqualTo(String value) {
            addCriterion("VALID_DATE >=", value, "validDate");
            return (Criteria) this;
        }

        public Criteria andValidDateLessThan(String value) {
            addCriterion("VALID_DATE <", value, "validDate");
            return (Criteria) this;
        }

        public Criteria andValidDateLessThanOrEqualTo(String value) {
            addCriterion("VALID_DATE <=", value, "validDate");
            return (Criteria) this;
        }

        public Criteria andValidDateLike(String value) {
            addCriterion("VALID_DATE like", value, "validDate");
            return (Criteria) this;
        }

        public Criteria andValidDateNotLike(String value) {
            addCriterion("VALID_DATE not like", value, "validDate");
            return (Criteria) this;
        }

        public Criteria andValidDateIn(List<String> values) {
            addCriterion("VALID_DATE in", values, "validDate");
            return (Criteria) this;
        }

        public Criteria andValidDateNotIn(List<String> values) {
            addCriterion("VALID_DATE not in", values, "validDate");
            return (Criteria) this;
        }

        public Criteria andValidDateBetween(String value1, String value2) {
            addCriterion("VALID_DATE between", value1, value2, "validDate");
            return (Criteria) this;
        }

        public Criteria andValidDateNotBetween(String value1, String value2) {
            addCriterion("VALID_DATE not between", value1, value2, "validDate");
            return (Criteria) this;
        }

        public Criteria andExpireDateIsNull() {
            addCriterion("EXPIRE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andExpireDateIsNotNull() {
            addCriterion("EXPIRE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andExpireDateEqualTo(String value) {
            addCriterion("EXPIRE_DATE =", value, "expireDate");
            return (Criteria) this;
        }

        public Criteria andExpireDateNotEqualTo(String value) {
            addCriterion("EXPIRE_DATE <>", value, "expireDate");
            return (Criteria) this;
        }

        public Criteria andExpireDateGreaterThan(String value) {
            addCriterion("EXPIRE_DATE >", value, "expireDate");
            return (Criteria) this;
        }

        public Criteria andExpireDateGreaterThanOrEqualTo(String value) {
            addCriterion("EXPIRE_DATE >=", value, "expireDate");
            return (Criteria) this;
        }

        public Criteria andExpireDateLessThan(String value) {
            addCriterion("EXPIRE_DATE <", value, "expireDate");
            return (Criteria) this;
        }

        public Criteria andExpireDateLessThanOrEqualTo(String value) {
            addCriterion("EXPIRE_DATE <=", value, "expireDate");
            return (Criteria) this;
        }

        public Criteria andExpireDateLike(String value) {
            addCriterion("EXPIRE_DATE like", value, "expireDate");
            return (Criteria) this;
        }

        public Criteria andExpireDateNotLike(String value) {
            addCriterion("EXPIRE_DATE not like", value, "expireDate");
            return (Criteria) this;
        }

        public Criteria andExpireDateIn(List<String> values) {
            addCriterion("EXPIRE_DATE in", values, "expireDate");
            return (Criteria) this;
        }

        public Criteria andExpireDateNotIn(List<String> values) {
            addCriterion("EXPIRE_DATE not in", values, "expireDate");
            return (Criteria) this;
        }

        public Criteria andExpireDateBetween(String value1, String value2) {
            addCriterion("EXPIRE_DATE between", value1, value2, "expireDate");
            return (Criteria) this;
        }

        public Criteria andExpireDateNotBetween(String value1, String value2) {
            addCriterion("EXPIRE_DATE not between", value1, value2, "expireDate");
            return (Criteria) this;
        }

        public Criteria andInPropIsNull() {
            addCriterion("IN_PROP is null");
            return (Criteria) this;
        }

        public Criteria andInPropIsNotNull() {
            addCriterion("IN_PROP is not null");
            return (Criteria) this;
        }

        public Criteria andInPropEqualTo(String value) {
            addCriterion("IN_PROP =", value, "inProp");
            return (Criteria) this;
        }

        public Criteria andInPropNotEqualTo(String value) {
            addCriterion("IN_PROP <>", value, "inProp");
            return (Criteria) this;
        }

        public Criteria andInPropGreaterThan(String value) {
            addCriterion("IN_PROP >", value, "inProp");
            return (Criteria) this;
        }

        public Criteria andInPropGreaterThanOrEqualTo(String value) {
            addCriterion("IN_PROP >=", value, "inProp");
            return (Criteria) this;
        }

        public Criteria andInPropLessThan(String value) {
            addCriterion("IN_PROP <", value, "inProp");
            return (Criteria) this;
        }

        public Criteria andInPropLessThanOrEqualTo(String value) {
            addCriterion("IN_PROP <=", value, "inProp");
            return (Criteria) this;
        }

        public Criteria andInPropLike(String value) {
            addCriterion("IN_PROP like", value, "inProp");
            return (Criteria) this;
        }

        public Criteria andInPropNotLike(String value) {
            addCriterion("IN_PROP not like", value, "inProp");
            return (Criteria) this;
        }

        public Criteria andInPropIn(List<String> values) {
            addCriterion("IN_PROP in", values, "inProp");
            return (Criteria) this;
        }

        public Criteria andInPropNotIn(List<String> values) {
            addCriterion("IN_PROP not in", values, "inProp");
            return (Criteria) this;
        }

        public Criteria andInPropBetween(String value1, String value2) {
            addCriterion("IN_PROP between", value1, value2, "inProp");
            return (Criteria) this;
        }

        public Criteria andInPropNotBetween(String value1, String value2) {
            addCriterion("IN_PROP not between", value1, value2, "inProp");
            return (Criteria) this;
        }

        public Criteria andOutPropIsNull() {
            addCriterion("OUT_PROP is null");
            return (Criteria) this;
        }

        public Criteria andOutPropIsNotNull() {
            addCriterion("OUT_PROP is not null");
            return (Criteria) this;
        }

        public Criteria andOutPropEqualTo(String value) {
            addCriterion("OUT_PROP =", value, "outProp");
            return (Criteria) this;
        }

        public Criteria andOutPropNotEqualTo(String value) {
            addCriterion("OUT_PROP <>", value, "outProp");
            return (Criteria) this;
        }

        public Criteria andOutPropGreaterThan(String value) {
            addCriterion("OUT_PROP >", value, "outProp");
            return (Criteria) this;
        }

        public Criteria andOutPropGreaterThanOrEqualTo(String value) {
            addCriterion("OUT_PROP >=", value, "outProp");
            return (Criteria) this;
        }

        public Criteria andOutPropLessThan(String value) {
            addCriterion("OUT_PROP <", value, "outProp");
            return (Criteria) this;
        }

        public Criteria andOutPropLessThanOrEqualTo(String value) {
            addCriterion("OUT_PROP <=", value, "outProp");
            return (Criteria) this;
        }

        public Criteria andOutPropLike(String value) {
            addCriterion("OUT_PROP like", value, "outProp");
            return (Criteria) this;
        }

        public Criteria andOutPropNotLike(String value) {
            addCriterion("OUT_PROP not like", value, "outProp");
            return (Criteria) this;
        }

        public Criteria andOutPropIn(List<String> values) {
            addCriterion("OUT_PROP in", values, "outProp");
            return (Criteria) this;
        }

        public Criteria andOutPropNotIn(List<String> values) {
            addCriterion("OUT_PROP not in", values, "outProp");
            return (Criteria) this;
        }

        public Criteria andOutPropBetween(String value1, String value2) {
            addCriterion("OUT_PROP between", value1, value2, "outProp");
            return (Criteria) this;
        }

        public Criteria andOutPropNotBetween(String value1, String value2) {
            addCriterion("OUT_PROP not between", value1, value2, "outProp");
            return (Criteria) this;
        }

        public Criteria andCountIsNull() {
            addCriterion("COUNT is null");
            return (Criteria) this;
        }

        public Criteria andCountIsNotNull() {
            addCriterion("COUNT is not null");
            return (Criteria) this;
        }

        public Criteria andCountEqualTo(String value) {
            addCriterion("COUNT =", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountNotEqualTo(String value) {
            addCriterion("COUNT <>", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountGreaterThan(String value) {
            addCriterion("COUNT >", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountGreaterThanOrEqualTo(String value) {
            addCriterion("COUNT >=", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountLessThan(String value) {
            addCriterion("COUNT <", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountLessThanOrEqualTo(String value) {
            addCriterion("COUNT <=", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountLike(String value) {
            addCriterion("COUNT like", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountNotLike(String value) {
            addCriterion("COUNT not like", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountIn(List<String> values) {
            addCriterion("COUNT in", values, "count");
            return (Criteria) this;
        }

        public Criteria andCountNotIn(List<String> values) {
            addCriterion("COUNT not in", values, "count");
            return (Criteria) this;
        }

        public Criteria andCountBetween(String value1, String value2) {
            addCriterion("COUNT between", value1, value2, "count");
            return (Criteria) this;
        }

        public Criteria andCountNotBetween(String value1, String value2) {
            addCriterion("COUNT not between", value1, value2, "count");
            return (Criteria) this;
        }

        public Criteria andReConfirmIsNull() {
            addCriterion("RE_CONFIRM is null");
            return (Criteria) this;
        }

        public Criteria andReConfirmIsNotNull() {
            addCriterion("RE_CONFIRM is not null");
            return (Criteria) this;
        }

        public Criteria andReConfirmEqualTo(String value) {
            addCriterion("RE_CONFIRM =", value, "reConfirm");
            return (Criteria) this;
        }

        public Criteria andReConfirmNotEqualTo(String value) {
            addCriterion("RE_CONFIRM <>", value, "reConfirm");
            return (Criteria) this;
        }

        public Criteria andReConfirmGreaterThan(String value) {
            addCriterion("RE_CONFIRM >", value, "reConfirm");
            return (Criteria) this;
        }

        public Criteria andReConfirmGreaterThanOrEqualTo(String value) {
            addCriterion("RE_CONFIRM >=", value, "reConfirm");
            return (Criteria) this;
        }

        public Criteria andReConfirmLessThan(String value) {
            addCriterion("RE_CONFIRM <", value, "reConfirm");
            return (Criteria) this;
        }

        public Criteria andReConfirmLessThanOrEqualTo(String value) {
            addCriterion("RE_CONFIRM <=", value, "reConfirm");
            return (Criteria) this;
        }

        public Criteria andReConfirmLike(String value) {
            addCriterion("RE_CONFIRM like", value, "reConfirm");
            return (Criteria) this;
        }

        public Criteria andReConfirmNotLike(String value) {
            addCriterion("RE_CONFIRM not like", value, "reConfirm");
            return (Criteria) this;
        }

        public Criteria andReConfirmIn(List<String> values) {
            addCriterion("RE_CONFIRM in", values, "reConfirm");
            return (Criteria) this;
        }

        public Criteria andReConfirmNotIn(List<String> values) {
            addCriterion("RE_CONFIRM not in", values, "reConfirm");
            return (Criteria) this;
        }

        public Criteria andReConfirmBetween(String value1, String value2) {
            addCriterion("RE_CONFIRM between", value1, value2, "reConfirm");
            return (Criteria) this;
        }

        public Criteria andReConfirmNotBetween(String value1, String value2) {
            addCriterion("RE_CONFIRM not between", value1, value2, "reConfirm");
            return (Criteria) this;
        }

        public Criteria andDeductClueIsNull() {
            addCriterion("DEDUCT_CLUE is null");
            return (Criteria) this;
        }

        public Criteria andDeductClueIsNotNull() {
            addCriterion("DEDUCT_CLUE is not null");
            return (Criteria) this;
        }

        public Criteria andDeductClueEqualTo(String value) {
            addCriterion("DEDUCT_CLUE =", value, "deductClue");
            return (Criteria) this;
        }

        public Criteria andDeductClueNotEqualTo(String value) {
            addCriterion("DEDUCT_CLUE <>", value, "deductClue");
            return (Criteria) this;
        }

        public Criteria andDeductClueGreaterThan(String value) {
            addCriterion("DEDUCT_CLUE >", value, "deductClue");
            return (Criteria) this;
        }

        public Criteria andDeductClueGreaterThanOrEqualTo(String value) {
            addCriterion("DEDUCT_CLUE >=", value, "deductClue");
            return (Criteria) this;
        }

        public Criteria andDeductClueLessThan(String value) {
            addCriterion("DEDUCT_CLUE <", value, "deductClue");
            return (Criteria) this;
        }

        public Criteria andDeductClueLessThanOrEqualTo(String value) {
            addCriterion("DEDUCT_CLUE <=", value, "deductClue");
            return (Criteria) this;
        }

        public Criteria andDeductClueLike(String value) {
            addCriterion("DEDUCT_CLUE like", value, "deductClue");
            return (Criteria) this;
        }

        public Criteria andDeductClueNotLike(String value) {
            addCriterion("DEDUCT_CLUE not like", value, "deductClue");
            return (Criteria) this;
        }

        public Criteria andDeductClueIn(List<String> values) {
            addCriterion("DEDUCT_CLUE in", values, "deductClue");
            return (Criteria) this;
        }

        public Criteria andDeductClueNotIn(List<String> values) {
            addCriterion("DEDUCT_CLUE not in", values, "deductClue");
            return (Criteria) this;
        }

        public Criteria andDeductClueBetween(String value1, String value2) {
            addCriterion("DEDUCT_CLUE between", value1, value2, "deductClue");
            return (Criteria) this;
        }

        public Criteria andDeductClueNotBetween(String value1, String value2) {
            addCriterion("DEDUCT_CLUE not between", value1, value2, "deductClue");
            return (Criteria) this;
        }

        public Criteria andQueryTdIsNull() {
            addCriterion("QUERY_TD is null");
            return (Criteria) this;
        }

        public Criteria andQueryTdIsNotNull() {
            addCriterion("QUERY_TD is not null");
            return (Criteria) this;
        }

        public Criteria andQueryTdEqualTo(String value) {
            addCriterion("QUERY_TD =", value, "queryTd");
            return (Criteria) this;
        }

        public Criteria andQueryTdNotEqualTo(String value) {
            addCriterion("QUERY_TD <>", value, "queryTd");
            return (Criteria) this;
        }

        public Criteria andQueryTdGreaterThan(String value) {
            addCriterion("QUERY_TD >", value, "queryTd");
            return (Criteria) this;
        }

        public Criteria andQueryTdGreaterThanOrEqualTo(String value) {
            addCriterion("QUERY_TD >=", value, "queryTd");
            return (Criteria) this;
        }

        public Criteria andQueryTdLessThan(String value) {
            addCriterion("QUERY_TD <", value, "queryTd");
            return (Criteria) this;
        }

        public Criteria andQueryTdLessThanOrEqualTo(String value) {
            addCriterion("QUERY_TD <=", value, "queryTd");
            return (Criteria) this;
        }

        public Criteria andQueryTdLike(String value) {
            addCriterion("QUERY_TD like", value, "queryTd");
            return (Criteria) this;
        }

        public Criteria andQueryTdNotLike(String value) {
            addCriterion("QUERY_TD not like", value, "queryTd");
            return (Criteria) this;
        }

        public Criteria andQueryTdIn(List<String> values) {
            addCriterion("QUERY_TD in", values, "queryTd");
            return (Criteria) this;
        }

        public Criteria andQueryTdNotIn(List<String> values) {
            addCriterion("QUERY_TD not in", values, "queryTd");
            return (Criteria) this;
        }

        public Criteria andQueryTdBetween(String value1, String value2) {
            addCriterion("QUERY_TD between", value1, value2, "queryTd");
            return (Criteria) this;
        }

        public Criteria andQueryTdNotBetween(String value1, String value2) {
            addCriterion("QUERY_TD not between", value1, value2, "queryTd");
            return (Criteria) this;
        }

        public Criteria andSimsTimeIsNull() {
            addCriterion("SIMS_TIME is null");
            return (Criteria) this;
        }

        public Criteria andSimsTimeIsNotNull() {
            addCriterion("SIMS_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andSimsTimeEqualTo(String value) {
            addCriterion("SIMS_TIME =", value, "simsTime");
            return (Criteria) this;
        }

        public Criteria andSimsTimeNotEqualTo(String value) {
            addCriterion("SIMS_TIME <>", value, "simsTime");
            return (Criteria) this;
        }

        public Criteria andSimsTimeGreaterThan(String value) {
            addCriterion("SIMS_TIME >", value, "simsTime");
            return (Criteria) this;
        }

        public Criteria andSimsTimeGreaterThanOrEqualTo(String value) {
            addCriterion("SIMS_TIME >=", value, "simsTime");
            return (Criteria) this;
        }

        public Criteria andSimsTimeLessThan(String value) {
            addCriterion("SIMS_TIME <", value, "simsTime");
            return (Criteria) this;
        }

        public Criteria andSimsTimeLessThanOrEqualTo(String value) {
            addCriterion("SIMS_TIME <=", value, "simsTime");
            return (Criteria) this;
        }

        public Criteria andSimsTimeLike(String value) {
            addCriterion("SIMS_TIME like", value, "simsTime");
            return (Criteria) this;
        }

        public Criteria andSimsTimeNotLike(String value) {
            addCriterion("SIMS_TIME not like", value, "simsTime");
            return (Criteria) this;
        }

        public Criteria andSimsTimeIn(List<String> values) {
            addCriterion("SIMS_TIME in", values, "simsTime");
            return (Criteria) this;
        }

        public Criteria andSimsTimeNotIn(List<String> values) {
            addCriterion("SIMS_TIME not in", values, "simsTime");
            return (Criteria) this;
        }

        public Criteria andSimsTimeBetween(String value1, String value2) {
            addCriterion("SIMS_TIME between", value1, value2, "simsTime");
            return (Criteria) this;
        }

        public Criteria andSimsTimeNotBetween(String value1, String value2) {
            addCriterion("SIMS_TIME not between", value1, value2, "simsTime");
            return (Criteria) this;
        }

        public Criteria andDeductModeIsNull() {
            addCriterion("DEDUCT_MODE is null");
            return (Criteria) this;
        }

        public Criteria andDeductModeIsNotNull() {
            addCriterion("DEDUCT_MODE is not null");
            return (Criteria) this;
        }

        public Criteria andDeductModeEqualTo(String value) {
            addCriterion("DEDUCT_MODE =", value, "deductMode");
            return (Criteria) this;
        }

        public Criteria andDeductModeNotEqualTo(String value) {
            addCriterion("DEDUCT_MODE <>", value, "deductMode");
            return (Criteria) this;
        }

        public Criteria andDeductModeGreaterThan(String value) {
            addCriterion("DEDUCT_MODE >", value, "deductMode");
            return (Criteria) this;
        }

        public Criteria andDeductModeGreaterThanOrEqualTo(String value) {
            addCriterion("DEDUCT_MODE >=", value, "deductMode");
            return (Criteria) this;
        }

        public Criteria andDeductModeLessThan(String value) {
            addCriterion("DEDUCT_MODE <", value, "deductMode");
            return (Criteria) this;
        }

        public Criteria andDeductModeLessThanOrEqualTo(String value) {
            addCriterion("DEDUCT_MODE <=", value, "deductMode");
            return (Criteria) this;
        }

        public Criteria andDeductModeLike(String value) {
            addCriterion("DEDUCT_MODE like", value, "deductMode");
            return (Criteria) this;
        }

        public Criteria andDeductModeNotLike(String value) {
            addCriterion("DEDUCT_MODE not like", value, "deductMode");
            return (Criteria) this;
        }

        public Criteria andDeductModeIn(List<String> values) {
            addCriterion("DEDUCT_MODE in", values, "deductMode");
            return (Criteria) this;
        }

        public Criteria andDeductModeNotIn(List<String> values) {
            addCriterion("DEDUCT_MODE not in", values, "deductMode");
            return (Criteria) this;
        }

        public Criteria andDeductModeBetween(String value1, String value2) {
            addCriterion("DEDUCT_MODE between", value1, value2, "deductMode");
            return (Criteria) this;
        }

        public Criteria andDeductModeNotBetween(String value1, String value2) {
            addCriterion("DEDUCT_MODE not between", value1, value2, "deductMode");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNull() {
            addCriterion("CREATE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNotNull() {
            addCriterion("CREATE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDateEqualTo(Date value) {
            addCriterion("CREATE_DATE =", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotEqualTo(Date value) {
            addCriterion("CREATE_DATE <>", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThan(Date value) {
            addCriterion("CREATE_DATE >", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_DATE >=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThan(Date value) {
            addCriterion("CREATE_DATE <", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_DATE <=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateIn(List<Date> values) {
            addCriterion("CREATE_DATE in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotIn(List<Date> values) {
            addCriterion("CREATE_DATE not in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateBetween(Date value1, Date value2) {
            addCriterion("CREATE_DATE between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_DATE not between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andOperTypeIsNull() {
            addCriterion("OPER_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andOperTypeIsNotNull() {
            addCriterion("OPER_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andOperTypeEqualTo(String value) {
            addCriterion("OPER_TYPE =", value, "operType");
            return (Criteria) this;
        }

        public Criteria andOperTypeNotEqualTo(String value) {
            addCriterion("OPER_TYPE <>", value, "operType");
            return (Criteria) this;
        }

        public Criteria andOperTypeGreaterThan(String value) {
            addCriterion("OPER_TYPE >", value, "operType");
            return (Criteria) this;
        }

        public Criteria andOperTypeGreaterThanOrEqualTo(String value) {
            addCriterion("OPER_TYPE >=", value, "operType");
            return (Criteria) this;
        }

        public Criteria andOperTypeLessThan(String value) {
            addCriterion("OPER_TYPE <", value, "operType");
            return (Criteria) this;
        }

        public Criteria andOperTypeLessThanOrEqualTo(String value) {
            addCriterion("OPER_TYPE <=", value, "operType");
            return (Criteria) this;
        }

        public Criteria andOperTypeLike(String value) {
            addCriterion("OPER_TYPE like", value, "operType");
            return (Criteria) this;
        }

        public Criteria andOperTypeNotLike(String value) {
            addCriterion("OPER_TYPE not like", value, "operType");
            return (Criteria) this;
        }

        public Criteria andOperTypeIn(List<String> values) {
            addCriterion("OPER_TYPE in", values, "operType");
            return (Criteria) this;
        }

        public Criteria andOperTypeNotIn(List<String> values) {
            addCriterion("OPER_TYPE not in", values, "operType");
            return (Criteria) this;
        }

        public Criteria andOperTypeBetween(String value1, String value2) {
            addCriterion("OPER_TYPE between", value1, value2, "operType");
            return (Criteria) this;
        }

        public Criteria andOperTypeNotBetween(String value1, String value2) {
            addCriterion("OPER_TYPE not between", value1, value2, "operType");
            return (Criteria) this;
        }

        public Criteria andIsDayBillIsNull() {
            addCriterion("IS_DAY_BILL is null");
            return (Criteria) this;
        }

        public Criteria andIsDayBillIsNotNull() {
            addCriterion("IS_DAY_BILL is not null");
            return (Criteria) this;
        }

        public Criteria andIsDayBillEqualTo(String value) {
            addCriterion("IS_DAY_BILL =", value, "isDayBill");
            return (Criteria) this;
        }

        public Criteria andIsDayBillNotEqualTo(String value) {
            addCriterion("IS_DAY_BILL <>", value, "isDayBill");
            return (Criteria) this;
        }

        public Criteria andIsDayBillGreaterThan(String value) {
            addCriterion("IS_DAY_BILL >", value, "isDayBill");
            return (Criteria) this;
        }

        public Criteria andIsDayBillGreaterThanOrEqualTo(String value) {
            addCriterion("IS_DAY_BILL >=", value, "isDayBill");
            return (Criteria) this;
        }

        public Criteria andIsDayBillLessThan(String value) {
            addCriterion("IS_DAY_BILL <", value, "isDayBill");
            return (Criteria) this;
        }

        public Criteria andIsDayBillLessThanOrEqualTo(String value) {
            addCriterion("IS_DAY_BILL <=", value, "isDayBill");
            return (Criteria) this;
        }

        public Criteria andIsDayBillLike(String value) {
            addCriterion("IS_DAY_BILL like", value, "isDayBill");
            return (Criteria) this;
        }

        public Criteria andIsDayBillNotLike(String value) {
            addCriterion("IS_DAY_BILL not like", value, "isDayBill");
            return (Criteria) this;
        }

        public Criteria andIsDayBillIn(List<String> values) {
            addCriterion("IS_DAY_BILL in", values, "isDayBill");
            return (Criteria) this;
        }

        public Criteria andIsDayBillNotIn(List<String> values) {
            addCriterion("IS_DAY_BILL not in", values, "isDayBill");
            return (Criteria) this;
        }

        public Criteria andIsDayBillBetween(String value1, String value2) {
            addCriterion("IS_DAY_BILL between", value1, value2, "isDayBill");
            return (Criteria) this;
        }

        public Criteria andIsDayBillNotBetween(String value1, String value2) {
            addCriterion("IS_DAY_BILL not between", value1, value2, "isDayBill");
            return (Criteria) this;
        }

        public Criteria andMarketingBalIsNull() {
            addCriterion("MARKETING_BAL is null");
            return (Criteria) this;
        }

        public Criteria andMarketingBalIsNotNull() {
            addCriterion("MARKETING_BAL is not null");
            return (Criteria) this;
        }

        public Criteria andMarketingBalEqualTo(String value) {
            addCriterion("MARKETING_BAL =", value, "marketingBal");
            return (Criteria) this;
        }

        public Criteria andMarketingBalNotEqualTo(String value) {
            addCriterion("MARKETING_BAL <>", value, "marketingBal");
            return (Criteria) this;
        }

        public Criteria andMarketingBalGreaterThan(String value) {
            addCriterion("MARKETING_BAL >", value, "marketingBal");
            return (Criteria) this;
        }

        public Criteria andMarketingBalGreaterThanOrEqualTo(String value) {
            addCriterion("MARKETING_BAL >=", value, "marketingBal");
            return (Criteria) this;
        }

        public Criteria andMarketingBalLessThan(String value) {
            addCriterion("MARKETING_BAL <", value, "marketingBal");
            return (Criteria) this;
        }

        public Criteria andMarketingBalLessThanOrEqualTo(String value) {
            addCriterion("MARKETING_BAL <=", value, "marketingBal");
            return (Criteria) this;
        }

        public Criteria andMarketingBalLike(String value) {
            addCriterion("MARKETING_BAL like", value, "marketingBal");
            return (Criteria) this;
        }

        public Criteria andMarketingBalNotLike(String value) {
            addCriterion("MARKETING_BAL not like", value, "marketingBal");
            return (Criteria) this;
        }

        public Criteria andMarketingBalIn(List<String> values) {
            addCriterion("MARKETING_BAL in", values, "marketingBal");
            return (Criteria) this;
        }

        public Criteria andMarketingBalNotIn(List<String> values) {
            addCriterion("MARKETING_BAL not in", values, "marketingBal");
            return (Criteria) this;
        }

        public Criteria andMarketingBalBetween(String value1, String value2) {
            addCriterion("MARKETING_BAL between", value1, value2, "marketingBal");
            return (Criteria) this;
        }

        public Criteria andMarketingBalNotBetween(String value1, String value2) {
            addCriterion("MARKETING_BAL not between", value1, value2, "marketingBal");
            return (Criteria) this;
        }

        public Criteria andBalDiscountIsNull() {
            addCriterion("BAL_DISCOUNT is null");
            return (Criteria) this;
        }

        public Criteria andBalDiscountIsNotNull() {
            addCriterion("BAL_DISCOUNT is not null");
            return (Criteria) this;
        }

        public Criteria andBalDiscountEqualTo(String value) {
            addCriterion("BAL_DISCOUNT =", value, "balDiscount");
            return (Criteria) this;
        }

        public Criteria andBalDiscountNotEqualTo(String value) {
            addCriterion("BAL_DISCOUNT <>", value, "balDiscount");
            return (Criteria) this;
        }

        public Criteria andBalDiscountGreaterThan(String value) {
            addCriterion("BAL_DISCOUNT >", value, "balDiscount");
            return (Criteria) this;
        }

        public Criteria andBalDiscountGreaterThanOrEqualTo(String value) {
            addCriterion("BAL_DISCOUNT >=", value, "balDiscount");
            return (Criteria) this;
        }

        public Criteria andBalDiscountLessThan(String value) {
            addCriterion("BAL_DISCOUNT <", value, "balDiscount");
            return (Criteria) this;
        }

        public Criteria andBalDiscountLessThanOrEqualTo(String value) {
            addCriterion("BAL_DISCOUNT <=", value, "balDiscount");
            return (Criteria) this;
        }

        public Criteria andBalDiscountLike(String value) {
            addCriterion("BAL_DISCOUNT like", value, "balDiscount");
            return (Criteria) this;
        }

        public Criteria andBalDiscountNotLike(String value) {
            addCriterion("BAL_DISCOUNT not like", value, "balDiscount");
            return (Criteria) this;
        }

        public Criteria andBalDiscountIn(List<String> values) {
            addCriterion("BAL_DISCOUNT in", values, "balDiscount");
            return (Criteria) this;
        }

        public Criteria andBalDiscountNotIn(List<String> values) {
            addCriterion("BAL_DISCOUNT not in", values, "balDiscount");
            return (Criteria) this;
        }

        public Criteria andBalDiscountBetween(String value1, String value2) {
            addCriterion("BAL_DISCOUNT between", value1, value2, "balDiscount");
            return (Criteria) this;
        }

        public Criteria andBalDiscountNotBetween(String value1, String value2) {
            addCriterion("BAL_DISCOUNT not between", value1, value2, "balDiscount");
            return (Criteria) this;
        }

        public Criteria andDupOrderIsNull() {
            addCriterion("DUP_ORDER is null");
            return (Criteria) this;
        }

        public Criteria andDupOrderIsNotNull() {
            addCriterion("DUP_ORDER is not null");
            return (Criteria) this;
        }

        public Criteria andDupOrderEqualTo(String value) {
            addCriterion("DUP_ORDER =", value, "dupOrder");
            return (Criteria) this;
        }

        public Criteria andDupOrderNotEqualTo(String value) {
            addCriterion("DUP_ORDER <>", value, "dupOrder");
            return (Criteria) this;
        }

        public Criteria andDupOrderGreaterThan(String value) {
            addCriterion("DUP_ORDER >", value, "dupOrder");
            return (Criteria) this;
        }

        public Criteria andDupOrderGreaterThanOrEqualTo(String value) {
            addCriterion("DUP_ORDER >=", value, "dupOrder");
            return (Criteria) this;
        }

        public Criteria andDupOrderLessThan(String value) {
            addCriterion("DUP_ORDER <", value, "dupOrder");
            return (Criteria) this;
        }

        public Criteria andDupOrderLessThanOrEqualTo(String value) {
            addCriterion("DUP_ORDER <=", value, "dupOrder");
            return (Criteria) this;
        }

        public Criteria andDupOrderLike(String value) {
            addCriterion("DUP_ORDER like", value, "dupOrder");
            return (Criteria) this;
        }

        public Criteria andDupOrderNotLike(String value) {
            addCriterion("DUP_ORDER not like", value, "dupOrder");
            return (Criteria) this;
        }

        public Criteria andDupOrderIn(List<String> values) {
            addCriterion("DUP_ORDER in", values, "dupOrder");
            return (Criteria) this;
        }

        public Criteria andDupOrderNotIn(List<String> values) {
            addCriterion("DUP_ORDER not in", values, "dupOrder");
            return (Criteria) this;
        }

        public Criteria andDupOrderBetween(String value1, String value2) {
            addCriterion("DUP_ORDER between", value1, value2, "dupOrder");
            return (Criteria) this;
        }

        public Criteria andDupOrderNotBetween(String value1, String value2) {
            addCriterion("DUP_ORDER not between", value1, value2, "dupOrder");
            return (Criteria) this;
        }

        public Criteria andSettlModeIsNull() {
            addCriterion("SETTL_MODE is null");
            return (Criteria) this;
        }

        public Criteria andSettlModeIsNotNull() {
            addCriterion("SETTL_MODE is not null");
            return (Criteria) this;
        }

        public Criteria andSettlModeEqualTo(String value) {
            addCriterion("SETTL_MODE =", value, "settlMode");
            return (Criteria) this;
        }

        public Criteria andSettlModeNotEqualTo(String value) {
            addCriterion("SETTL_MODE <>", value, "settlMode");
            return (Criteria) this;
        }

        public Criteria andSettlModeGreaterThan(String value) {
            addCriterion("SETTL_MODE >", value, "settlMode");
            return (Criteria) this;
        }

        public Criteria andSettlModeGreaterThanOrEqualTo(String value) {
            addCriterion("SETTL_MODE >=", value, "settlMode");
            return (Criteria) this;
        }

        public Criteria andSettlModeLessThan(String value) {
            addCriterion("SETTL_MODE <", value, "settlMode");
            return (Criteria) this;
        }

        public Criteria andSettlModeLessThanOrEqualTo(String value) {
            addCriterion("SETTL_MODE <=", value, "settlMode");
            return (Criteria) this;
        }

        public Criteria andSettlModeLike(String value) {
            addCriterion("SETTL_MODE like", value, "settlMode");
            return (Criteria) this;
        }

        public Criteria andSettlModeNotLike(String value) {
            addCriterion("SETTL_MODE not like", value, "settlMode");
            return (Criteria) this;
        }

        public Criteria andSettlModeIn(List<String> values) {
            addCriterion("SETTL_MODE in", values, "settlMode");
            return (Criteria) this;
        }

        public Criteria andSettlModeNotIn(List<String> values) {
            addCriterion("SETTL_MODE not in", values, "settlMode");
            return (Criteria) this;
        }

        public Criteria andSettlModeBetween(String value1, String value2) {
            addCriterion("SETTL_MODE between", value1, value2, "settlMode");
            return (Criteria) this;
        }

        public Criteria andSettlModeNotBetween(String value1, String value2) {
            addCriterion("SETTL_MODE not between", value1, value2, "settlMode");
            return (Criteria) this;
        }

        public Criteria andSettlAmountIsNull() {
            addCriterion("SETTL_AMOUNT is null");
            return (Criteria) this;
        }

        public Criteria andSettlAmountIsNotNull() {
            addCriterion("SETTL_AMOUNT is not null");
            return (Criteria) this;
        }

        public Criteria andSettlAmountEqualTo(String value) {
            addCriterion("SETTL_AMOUNT =", value, "settlAmount");
            return (Criteria) this;
        }

        public Criteria andSettlAmountNotEqualTo(String value) {
            addCriterion("SETTL_AMOUNT <>", value, "settlAmount");
            return (Criteria) this;
        }

        public Criteria andSettlAmountGreaterThan(String value) {
            addCriterion("SETTL_AMOUNT >", value, "settlAmount");
            return (Criteria) this;
        }

        public Criteria andSettlAmountGreaterThanOrEqualTo(String value) {
            addCriterion("SETTL_AMOUNT >=", value, "settlAmount");
            return (Criteria) this;
        }

        public Criteria andSettlAmountLessThan(String value) {
            addCriterion("SETTL_AMOUNT <", value, "settlAmount");
            return (Criteria) this;
        }

        public Criteria andSettlAmountLessThanOrEqualTo(String value) {
            addCriterion("SETTL_AMOUNT <=", value, "settlAmount");
            return (Criteria) this;
        }

        public Criteria andSettlAmountLike(String value) {
            addCriterion("SETTL_AMOUNT like", value, "settlAmount");
            return (Criteria) this;
        }

        public Criteria andSettlAmountNotLike(String value) {
            addCriterion("SETTL_AMOUNT not like", value, "settlAmount");
            return (Criteria) this;
        }

        public Criteria andSettlAmountIn(List<String> values) {
            addCriterion("SETTL_AMOUNT in", values, "settlAmount");
            return (Criteria) this;
        }

        public Criteria andSettlAmountNotIn(List<String> values) {
            addCriterion("SETTL_AMOUNT not in", values, "settlAmount");
            return (Criteria) this;
        }

        public Criteria andSettlAmountBetween(String value1, String value2) {
            addCriterion("SETTL_AMOUNT between", value1, value2, "settlAmount");
            return (Criteria) this;
        }

        public Criteria andSettlAmountNotBetween(String value1, String value2) {
            addCriterion("SETTL_AMOUNT not between", value1, value2, "settlAmount");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}